package com.crm.dao.mapper.customMapper.memberManagerCustomMapper;

import com.crm.model.entity.memberManager.CustomerMemberCard;
import com.crm.model.qo.memberManager.MemberShipCardQO;
import com.crm.model.vo.memberManager.MemberCardOldVO;
import com.crm.model.vo.memberManager.MemberShipCardListVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author luojie
 * @date 2021/4/8 15:02
 */
public interface MembershipCardCustomMapper {

    /***
     * @Description: 根据查询条件查询会员卡列表
     * @Param: 查询调教
     * @Author: luojie
     * @Date: 2021/4/8 15:04
     */
    List<MemberShipCardListVO> selectMemberShipCardList(@Param("memberShipCardQO")MemberShipCardQO memberShipCardQO);

    /**
     * 从会员卡表随机取一个未发放的会员卡
     * @return
     */
    CustomerMemberCard selectMemberShipCard();

    /***
     * @Description: 查询旧系统会员卡列表
     * @Param:
     * @Author: luojie
     * @Date: 2021/4/8 13:41
     */
    List<MemberCardOldVO> selectMemberCardOldList(@Param("memberShipCardQO")MemberShipCardQO memberShipCardQO);

    /***
     * @Description: 查询旧系统公司名称
     * @Param:
     * @Author: luojie
     * @Date: 2021/4/8 13:41
     */
    List<MemberCardOldVO> getCompanyList();

    /**
     * 查询会员卡开始时间和结束时间为空的
     * @return
     */
    List<MemberCardOldVO> selectCardDate();
}
